Profiling Report

Brought to you by YData

Dataset statistics

Number of variables	16
Number of observations	16747
Missing cells	5824
Missing cells (%)	2.2%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	2.2 MiB
Average record size in memory	136.0 B

Variable types

Numeric	10
Text	3
Categorical	2
DateTime	1

Alerts

`last_review` has 2905 (17.3%) missing values	Missing
`reviews_per_month` has 2905 (17.3%) missing values	Missing
`id` has unique values	Unique
`number_of_reviews` has 2905 (17.3%) zeros	Zeros
`availability_365` has 6635 (39.6%) zeros	Zeros

Reproduction

Analysis started	2025-04-25 09:23:31.205186
Analysis finished	2025-04-25 09:23:47.935220
Duration	16.73 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

id
Real number (ℝ)

Unique

Distinct	16747
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18733164

Minimum	2539
Maximum	36485609
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	261.7 KiB

Quantile statistics

Minimum	2539
5-th percentile	1224161.5
Q1	9287529.5
median	19317834
Q3	28616560
95-th percentile	35234760
Maximum	36485609
Range	36483070
Interquartile range (IQR)	19329031

Descriptive statistics

Standard deviation	10903901
Coefficient of variation (CV)	0.58206407
Kurtosis	-1.2113291
Mean	18733164
Median Absolute Deviation (MAD)	9719442
Skewness	-0.054980643
Sum	3.1372429 × 10¹¹
Variance	1.1889507 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9138664	1	< 0.1%
7885044	1	< 0.1%
20802860	1	< 0.1%
19387402	1	< 0.1%
32195520	1	< 0.1%
28978145	1	< 0.1%
28721018	1	< 0.1%
7308735	1	< 0.1%
35710560	1	< 0.1%
35084043	1	< 0.1%
Other values (16737)	16737	99.9%

Value	Count	Frequency (%)
2539	1	< 0.1%
3831	1	< 0.1%
5022	1	< 0.1%
5203	1	< 0.1%
5238	1	< 0.1%
5803	1	< 0.1%
6848	1	< 0.1%
7750	1	< 0.1%
7801	1	< 0.1%
8024	1	< 0.1%

Value	Count	Frequency (%)
36485609	1	< 0.1%
36485057	1	< 0.1%
36479723	1	< 0.1%
36478343	1	< 0.1%
36472171	1	< 0.1%
36471896	1	< 0.1%
36468880	1	< 0.1%
36458668	1	< 0.1%
36456829	1	< 0.1%
36455917	1	< 0.1%

name
Text

Distinct	16566
Distinct (%)	99.0%
Missing	7
Missing (%)	< 0.1%
Memory size	261.7 KiB

Length

Max length	179
Median length	56
Mean length	36.461051
Min length	1

Characters and Unicode

Total characters	610358
Distinct characters	489
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	16436 ?
Unique (%)	98.2%

Sample

1st row	Private Lg Room 15 min to Manhattan
2nd row	TIME SQUARE CHARMING ONE BED IN HELL'S KITCHEN,NYC
3rd row	Voted #1 Location Quintessential 1BR W Village Apt
4th row	Spacious 1 bedroom apartment 15min from Manhattan
5th row	Big beautiful bedroom in huge Bushwick apartment

Value	Count	Frequency (%)
in	5955	5.9%
room	3661	3.6%
bedroom	2688	2.7%
private	2639	2.6%
	2517	2.5%
apartment	2408	2.4%
cozy	1872	1.9%
apt	1535	1.5%
brooklyn	1508	1.5%
the	1393	1.4%
Other values (5970)	74697	74.1%

Most occurring characters

Value	Count	Frequency (%)
	84700	13.9%
o	42375	6.9%
e	42227	6.9%
t	36161	5.9%
a	35887	5.9%
r	33798	5.5%
i	32716	5.4%
n	32344	5.3%
l	17685	2.9%
m	17316	2.8%
Other values (479)	235149	38.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	610358	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	84700	13.9%
o	42375	6.9%
e	42227	6.9%
t	36161	5.9%
a	35887	5.9%
r	33798	5.5%
i	32716	5.4%
n	32344	5.3%
l	17685	2.9%
m	17316	2.8%
Other values (479)	235149	38.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	610358	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	84700	13.9%
o	42375	6.9%
e	42227	6.9%
t	36161	5.9%
a	35887	5.9%
r	33798	5.5%
i	32716	5.4%
n	32344	5.3%
l	17685	2.9%
m	17316	2.8%
Other values (479)	235149	38.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	610358	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	84700	13.9%
o	42375	6.9%
e	42227	6.9%
t	36161	5.9%
a	35887	5.9%
r	33798	5.5%
i	32716	5.4%
n	32344	5.3%
l	17685	2.9%
m	17316	2.8%
Other values (479)	235149	38.5%

host_id
Real number (ℝ)

Distinct	15004
Distinct (%)	89.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	66001283

Minimum	2571
Maximum	2.7427328 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	261.7 KiB

Quantile statistics

Minimum	2571
5-th percentile	773241.8
Q1	7748101
median	30523475
Q3	1.019804 × 10⁸
95-th percentile	2.4064613 × 10⁸
Maximum	2.7427328 × 10⁸
Range	2.7427071 × 10⁸
Interquartile range (IQR)	94232295

Descriptive statistics

Standard deviation	77701222
Coefficient of variation (CV)	1.1772684
Kurtosis	0.34747126
Mean	66001283
Median Absolute Deviation (MAD)	27039318
Skewness	1.2651272
Sum	1.1053235 × 10¹²
Variance	6.03748 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
219517861	63	0.4%
119669058	17	0.1%
190921808	14	0.1%
417504	12	0.1%
213781715	10	0.1%
5144567	9	0.1%
224414117	8	< 0.1%
252604696	8	< 0.1%
201015598	8	< 0.1%
211549023	7	< 0.1%
Other values (14994)	16591	99.1%

Value	Count	Frequency (%)
2571	1	< 0.1%
2787	3	< 0.1%
3151	1	< 0.1%
3415	1	< 0.1%
3563	1	< 0.1%
3647	2	< 0.1%
4396	1	< 0.1%
4869	1	< 0.1%
5089	1	< 0.1%
6041	1	< 0.1%

Value	Count	Frequency (%)
274273284	1	< 0.1%
274195458	1	< 0.1%
274103383	1	< 0.1%
273870123	1	< 0.1%
273841667	1	< 0.1%
273741577	1	< 0.1%
273656890	1	< 0.1%
273619304	1	< 0.1%
273613106	1	< 0.1%
273570019	1	< 0.1%

host_name
Text

Distinct	5968
Distinct (%)	35.7%
Missing	7
Missing (%)	< 0.1%
Memory size	261.7 KiB

Length

Max length	35
Median length	31
Mean length	6.0646953
Min length	1

Characters and Unicode

Total characters	101523
Distinct characters	134
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3921 ?
Unique (%)	23.4%

Sample

1st row	Iris
2nd row	Johlex
3rd row	John
4th row	Regan
5th row	Megan

Value	Count	Frequency (%)
	342	1.8%
and	208	1.1%
michael	151	0.8%
david	150	0.8%
john	121	0.7%
alex	107	0.6%
maria	99	0.5%
daniel	90	0.5%
sarah	87	0.5%
anna	80	0.4%
Other values (5596)	17067	92.2%

Most occurring characters

Value	Count	Frequency (%)
a	13092	12.9%
e	9896	9.7%
i	8409	8.3%
n	8272	8.1%
r	6041	6.0%
l	5251	5.2%
o	4246	4.2%
t	3209	3.2%
s	3186	3.1%
h	3164	3.1%
Other values (124)	36757	36.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	101523	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	13092	12.9%
e	9896	9.7%
i	8409	8.3%
n	8272	8.1%
r	6041	6.0%
l	5251	5.2%
o	4246	4.2%
t	3209	3.2%
s	3186	3.1%
h	3164	3.1%
Other values (124)	36757	36.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	101523	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	13092	12.9%
e	9896	9.7%
i	8409	8.3%
n	8272	8.1%
r	6041	6.0%
l	5251	5.2%
o	4246	4.2%
t	3209	3.2%
s	3186	3.1%
h	3164	3.1%
Other values (124)	36757	36.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	101523	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	13092	12.9%
e	9896	9.7%
i	8409	8.3%
n	8272	8.1%
r	6041	6.0%
l	5251	5.2%
o	4246	4.2%
t	3209	3.2%
s	3186	3.1%
h	3164	3.1%
Other values (124)	36757	36.2%

neighbourhood_group
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	261.7 KiB

Brooklyn	7334
Manhattan	6715
Queens	2135
Bronx	413
Staten Island	150

Length

Max length	13
Median length	9
Mean length	8.116797
Min length	5

Characters and Unicode

Total characters	135932
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Queens
2nd row	Manhattan
3rd row	Manhattan
4th row	Queens
5th row	Brooklyn

Common Values

Value	Count	Frequency (%)
Brooklyn	7334	43.8%
Manhattan	6715	40.1%
Queens	2135	12.7%
Bronx	413	2.5%
Staten Island	150	0.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
brooklyn	7334	43.4%
manhattan	6715	39.7%
queens	2135	12.6%
bronx	413	2.4%
staten	150	0.9%
island	150	0.9%

Most occurring characters

Value	Count	Frequency (%)
n	23612	17.4%
a	20445	15.0%
o	15081	11.1%
t	13730	10.1%
r	7747	5.7%
B	7747	5.7%
l	7484	5.5%
y	7334	5.4%
k	7334	5.4%
M	6715	4.9%
Other values (10)	18703	13.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	135932	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	23612	17.4%
a	20445	15.0%
o	15081	11.1%
t	13730	10.1%
r	7747	5.7%
B	7747	5.7%
l	7484	5.5%
y	7334	5.4%
k	7334	5.4%
M	6715	4.9%
Other values (10)	18703	13.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	135932	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	23612	17.4%
a	20445	15.0%
o	15081	11.1%
t	13730	10.1%
r	7747	5.7%
B	7747	5.7%
l	7484	5.5%
y	7334	5.4%
k	7334	5.4%
M	6715	4.9%
Other values (10)	18703	13.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	135932	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	23612	17.4%
a	20445	15.0%
o	15081	11.1%
t	13730	10.1%
r	7747	5.7%
B	7747	5.7%
l	7484	5.5%
y	7334	5.4%
k	7334	5.4%
M	6715	4.9%
Other values (10)	18703	13.8%

neighbourhood
Text

Distinct	215
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Memory size	261.7 KiB

Length

Max length	26
Median length	17
Mean length	11.913358
Min length	4

Characters and Unicode

Total characters	199513
Distinct characters	54
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	22 ?
Unique (%)	0.1%

Sample

1st row	Sunnyside
2nd row	Hell's Kitchen
3rd row	West Village
4th row	Astoria
5th row	Bushwick

Value	Count	Frequency (%)
east	2237	8.4%
side	1432	5.3%
williamsburg	1407	5.3%
harlem	1385	5.2%
bedford-stuyvesant	1343	5.0%
heights	1320	4.9%
upper	1116	4.2%
village	1049	3.9%
bushwick	880	3.3%
west	856	3.2%
Other values (227)	13760	51.4%

Most occurring characters

Value	Count	Frequency (%)
e	18133	9.1%
i	14026	7.0%
s	13940	7.0%
a	13151	6.6%
t	13140	6.6%
l	11714	5.9%
r	11707	5.9%
	10038	5.0%
n	9039	4.5%
o	8443	4.2%
Other values (44)	76182	38.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	199513	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	18133	9.1%
i	14026	7.0%
s	13940	7.0%
a	13151	6.6%
t	13140	6.6%
l	11714	5.9%
r	11707	5.9%
	10038	5.0%
n	9039	4.5%
o	8443	4.2%
Other values (44)	76182	38.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	199513	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	18133	9.1%
i	14026	7.0%
s	13940	7.0%
a	13151	6.6%
t	13140	6.6%
l	11714	5.9%
r	11707	5.9%
	10038	5.0%
n	9039	4.5%
o	8443	4.2%
Other values (44)	76182	38.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	199513	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	18133	9.1%
i	14026	7.0%
s	13940	7.0%
a	13151	6.6%
t	13140	6.6%
l	11714	5.9%
r	11707	5.9%
	10038	5.0%
n	9039	4.5%
o	8443	4.2%
Other values (44)	76182	38.2%

latitude
Real number (ℝ)

Distinct	11179
Distinct (%)	66.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	40.727028

Minimum	40.50873
Maximum	40.91306
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	261.7 KiB

Quantile statistics

Minimum	40.50873
5-th percentile	40.643146
Q1	40.687595
median	40.72007
Q3	40.76298
95-th percentile	40.827477
Maximum	40.91306
Range	0.40433
Interquartile range (IQR)	0.075385

Descriptive statistics

Standard deviation	0.056214402
Coefficient of variation (CV)	0.0013802726
Kurtosis	0.035075335
Mean	40.727028
Median Absolute Deviation (MAD)	0.03631
Skewness	0.28256433
Sum	682055.54
Variance	0.003160059
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40.68084	7	< 0.1%
40.71813	7	< 0.1%
40.68634	7	< 0.1%
40.68683	7	< 0.1%
40.72232	7	< 0.1%
40.69054	6	< 0.1%
40.77127	6	< 0.1%
40.72049	6	< 0.1%
40.72607	6	< 0.1%
40.68592	6	< 0.1%
Other values (11169)	16682	99.6%

Value	Count	Frequency (%)
40.50873	1	< 0.1%
40.52293	1	< 0.1%
40.53871	1	< 0.1%
40.53939	1	< 0.1%
40.54106	1	< 0.1%
40.54312	1	< 0.1%
40.5455	1	< 0.1%
40.54889	1	< 0.1%
40.54901	1	< 0.1%
40.55182	1	< 0.1%

Value	Count	Frequency (%)
40.91306	1	< 0.1%
40.90391	1	< 0.1%
40.90356	1	< 0.1%
40.90329	1	< 0.1%
40.90281	1	< 0.1%
40.9026	1	< 0.1%
40.89981	1	< 0.1%
40.89811	1	< 0.1%
40.89756	1	< 0.1%
40.89747	1	< 0.1%

longitude
Real number (ℝ)

Distinct	9323
Distinct (%)	55.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-73.949359

Minimum	-74.23914
Maximum	-73.71795
Zeros	0
Zeros (%)	0.0%
Negative	16747
Negative (%)	100.0%
Memory size	261.7 KiB

Quantile statistics

Minimum	-74.23914
5-th percentile	-74.00315
Q1	-73.98123
median	-73.95365
Q3	-73.932665
95-th percentile	-73.855294
Maximum	-73.71795
Range	0.52119
Interquartile range (IQR)	0.048565

Descriptive statistics

Standard deviation	0.047919729
Coefficient of variation (CV)	-0.00064800737
Kurtosis	4.5825772
Mean	-73.949359
Median Absolute Deviation (MAD)	0.02504
Skewness	1.2193676
Sum	-1238429.9
Variance	0.0022963004
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-73.98589	9	0.1%
-73.94829	8	< 0.1%
-73.95443	8	< 0.1%
-73.95121	8	< 0.1%
-73.95332	8	< 0.1%
-73.95107	8	< 0.1%
-73.95427	7	< 0.1%
-73.95688	7	< 0.1%
-73.95471	7	< 0.1%
-73.95476	7	< 0.1%
Other values (9313)	16670	99.5%

Value	Count	Frequency (%)
-74.23914	1	< 0.1%
-74.21238	1	< 0.1%
-74.19626	1	< 0.1%
-74.18259	1	< 0.1%
-74.17388	1	< 0.1%
-74.17117	1	< 0.1%
-74.17065	1	< 0.1%
-74.16966	1	< 0.1%
-74.16634	1	< 0.1%
-74.16558	1	< 0.1%

Value	Count	Frequency (%)
-73.71795	1	< 0.1%
-73.71829	1	< 0.1%
-73.72582	1	< 0.1%
-73.72716	1	< 0.1%
-73.72731	1	< 0.1%
-73.7274	1	< 0.1%
-73.72778	1	< 0.1%
-73.72817	1	< 0.1%
-73.72901	1	< 0.1%
-73.72928	1	< 0.1%

room_type
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	261.7 KiB

Private room	8316
Entire home/apt	8041
Shared room	390

Length

Max length	15
Median length	12
Mean length	13.417149
Min length	11

Characters and Unicode

Total characters	224697
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Private room
2nd row	Entire home/apt
3rd row	Entire home/apt
4th row	Entire home/apt
5th row	Private room

Common Values

Value	Count	Frequency (%)
Private room	8316	49.7%
Entire home/apt	8041	48.0%
Shared room	390	2.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
room	8706	26.0%
private	8316	24.8%
entire	8041	24.0%
home/apt	8041	24.0%
shared	390	1.2%

Most occurring characters

Value	Count	Frequency (%)
o	25453	11.3%
r	25453	11.3%
e	24788	11.0%
t	24398	10.9%
m	16747	7.5%
a	16747	7.5%
	16747	7.5%
i	16357	7.3%
h	8431	3.8%
P	8316	3.7%
Other values (7)	41260	18.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	224697	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	25453	11.3%
r	25453	11.3%
e	24788	11.0%
t	24398	10.9%
m	16747	7.5%
a	16747	7.5%
	16747	7.5%
i	16357	7.3%
h	8431	3.8%
P	8316	3.7%
Other values (7)	41260	18.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	224697	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	25453	11.3%
r	25453	11.3%
e	24788	11.0%
t	24398	10.9%
m	16747	7.5%
a	16747	7.5%
	16747	7.5%
i	16357	7.3%
h	8431	3.8%
P	8316	3.7%
Other values (7)	41260	18.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	224697	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	25453	11.3%
r	25453	11.3%
e	24788	11.0%
t	24398	10.9%
m	16747	7.5%
a	16747	7.5%
	16747	7.5%
i	16357	7.3%
h	8431	3.8%
P	8316	3.7%
Other values (7)	41260	18.4%

price
Real number (ℝ)

Distinct	302
Distinct (%)	1.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	121.08264

Minimum	10
Maximum	350
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	261.7 KiB

Quantile statistics

Minimum	10
5-th percentile	40
Q1	67
median	100
Q3	159
95-th percentile	265
Maximum	350
Range	340
Interquartile range (IQR)	92

Descriptive statistics

Standard deviation	70.664779
Coefficient of variation (CV)	0.58360784
Kurtosis	0.64243345
Mean	121.08264
Median Absolute Deviation (MAD)	41
Skewness	1.0754008
Sum	2027771
Variance	4993.511
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	783	4.7%
150	725	4.3%
50	582	3.5%
75	538	3.2%
200	528	3.2%
60	511	3.1%
80	493	2.9%
70	441	2.6%
65	438	2.6%
120	430	2.6%
Other values (292)	11278	67.3%

Value	Count	Frequency (%)
10	6	< 0.1%
11	2	< 0.1%
12	1	< 0.1%
13	1	< 0.1%
15	1	< 0.1%
16	3	< 0.1%
18	1	< 0.1%
19	2	< 0.1%
20	12	0.1%
21	3	< 0.1%

Value	Count	Frequency (%)
350	132	0.8%
349	14	0.1%
345	11	0.1%
344	1	< 0.1%
342	1	< 0.1%
341	1	< 0.1%
340	8	< 0.1%
339	4	< 0.1%
336	1	< 0.1%
335	3	< 0.1%

minimum_nights
Real number (ℝ)

Distinct	14
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.860572

Minimum	1
Maximum	14
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	261.7 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	3
95-th percentile	7
Maximum	14
Range	13
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	2.291717
Coefficient of variation (CV)	0.80113941
Kurtosis	7.0373867
Mean	2.860572
Median Absolute Deviation (MAD)	1
Skewness	2.3206945
Sum	47906
Variance	5.2519668
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
1	5003	29.9%
2	4619	27.6%
3	3086	18.4%
4	1253	7.5%
5	1140	6.8%
7	822	4.9%
6	285	1.7%
14	210	1.3%
10	178	1.1%
8	52	0.3%
Other values (4)	99	0.6%

Value	Count	Frequency (%)
1	5003	29.9%
2	4619	27.6%
3	3086	18.4%
4	1253	7.5%
5	1140	6.8%
6	285	1.7%
7	822	4.9%
8	52	0.3%
9	34	0.2%
10	178	1.1%

Value	Count	Frequency (%)
14	210	1.3%
13	20	0.1%
12	34	0.2%
11	11	0.1%
10	178	1.1%
9	34	0.2%
8	52	0.3%
7	822	4.9%
6	285	1.7%
5	1140	6.8%

number_of_reviews
Real number (ℝ)

Zeros

Distinct	320
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	25.856392

Minimum	0
Maximum	607
Zeros	2905
Zeros (%)	17.3%
Negative	0
Negative (%)	0.0%
Memory size	261.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	7
Q3	27
95-th percentile	123
Maximum	607
Range	607
Interquartile range (IQR)	26

Descriptive statistics

Standard deviation	47.30526
Coefficient of variation (CV)	1.8295383
Kurtosis	17.615739
Mean	25.856392
Median Absolute Deviation (MAD)	7
Skewness	3.5194961
Sum	433017
Variance	2237.7876
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2905	17.3%
1	1718	10.3%
2	1160	6.9%
3	844	5.0%
4	692	4.1%
5	521	3.1%
6	499	3.0%
7	439	2.6%
8	407	2.4%
9	345	2.1%
Other values (310)	7217	43.1%

Value	Count	Frequency (%)
0	2905	17.3%
1	1718	10.3%
2	1160	6.9%
3	844	5.0%
4	692	4.1%
5	521	3.1%
6	499	3.0%
7	439	2.6%
8	407	2.4%
9	345	2.1%

Value	Count	Frequency (%)
607	1	< 0.1%
594	1	< 0.1%
510	1	< 0.1%
488	1	< 0.1%
474	1	< 0.1%
466	1	< 0.1%
459	1	< 0.1%
448	1	< 0.1%
441	1	< 0.1%
439	1	< 0.1%

last_review
Date

Missing

Distinct	1444
Distinct (%)	10.4%
Missing	2905
Missing (%)	17.3%
Memory size	261.7 KiB

Minimum	2011-05-12 00:00:00
Maximum	2019-07-08 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

reviews_per_month
Real number (ℝ)

Missing

Distinct	789
Distinct (%)	5.7%
Missing	2905
Missing (%)	17.3%
Infinite	0
Infinite (%)	0.0%
Mean	1.4697789

Minimum	0.01
Maximum	27.95
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	261.7 KiB

Quantile statistics

Minimum	0.01
5-th percentile	0.04
Q1	0.21
median	0.83
Q3	2.18
95-th percentile	4.8195
Maximum	27.95
Range	27.94
Interquartile range (IQR)	1.97

Descriptive statistics

Standard deviation	1.7342197
Coefficient of variation (CV)	1.1799187
Kurtosis	11.316384
Mean	1.4697789
Median Absolute Deviation (MAD)	0.72
Skewness	2.3434648
Sum	20344.68
Variance	3.007518
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.02	344	2.1%
1	316	1.9%
0.05	296	1.8%
0.03	293	1.7%
0.08	227	1.4%
0.04	225	1.3%
0.16	216	1.3%
0.09	194	1.2%
0.06	189	1.1%
0.11	180	1.1%
Other values (779)	11362	67.8%
(Missing)	2905	17.3%

Value	Count	Frequency (%)
0.01	13	0.1%
0.02	344	2.1%
0.03	293	1.7%
0.04	225	1.3%
0.05	296	1.8%
0.06	189	1.1%
0.07	135	0.8%
0.08	227	1.4%
0.09	194	1.2%
0.1	155	0.9%

Value	Count	Frequency (%)
27.95	1	< 0.1%
20.94	1	< 0.1%
19.75	1	< 0.1%
17.82	1	< 0.1%
16.22	1	< 0.1%
13.45	1	< 0.1%
13.42	1	< 0.1%
13.24	1	< 0.1%
13.15	1	< 0.1%
12.99	1	< 0.1%

calculated_host_listings_count
Real number (ℝ)

Distinct	25
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.1051532

Minimum	1
Maximum	327
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	261.7 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	5
Maximum	327
Range	326
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	20.105021
Coefficient of variation (CV)	6.4747276
Kurtosis	250.53754
Mean	3.1051532
Median Absolute Deviation (MAD)	0
Skewness	15.751848
Sum	52002
Variance	404.21186
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
1	11762	70.2%
2	2397	14.3%
3	1024	6.1%
4	469	2.8%
5	290	1.7%
6	157	0.9%
7	132	0.8%
8	115	0.7%
9	65	0.4%
327	63	0.4%
Other values (15)	273	1.6%

Value	Count	Frequency (%)
1	11762	70.2%
2	2397	14.3%
3	1024	6.1%
4	469	2.8%
5	290	1.7%
6	157	0.9%
7	132	0.8%
8	115	0.7%
9	65	0.4%
10	51	0.3%

Value	Count	Frequency (%)
327	63	0.4%
47	14	0.1%
43	2	< 0.1%
34	17	0.1%
33	10	0.1%
30	8	< 0.1%
28	17	0.1%
26	5	< 0.1%
20	8	< 0.1%
18	7	< 0.1%

availability_365
Real number (ℝ)

Zeros

Distinct	366
Distinct (%)	2.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	97.520571

Minimum	0
Maximum	365
Zeros	6635
Zeros (%)	39.6%
Negative	0
Negative (%)	0.0%
Memory size	261.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	25
Q3	179
95-th percentile	353
Maximum	365
Range	365
Interquartile range (IQR)	179

Descriptive statistics

Standard deviation	124.83891
Coefficient of variation (CV)	1.280129
Kurtosis	-0.54187871
Mean	97.520571
Median Absolute Deviation (MAD)	25
Skewness	0.9897628
Sum	1633177
Variance	15584.753
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6635	39.6%
365	300	1.8%
1	149	0.9%
364	132	0.8%
5	124	0.7%
3	107	0.6%
6	105	0.6%
2	104	0.6%
179	102	0.6%
4	102	0.6%
Other values (356)	8887	53.1%

Value	Count	Frequency (%)
0	6635	39.6%
1	149	0.9%
2	104	0.6%
3	107	0.6%
4	102	0.6%
5	124	0.7%
6	105	0.6%
7	87	0.5%
8	82	0.5%
9	81	0.5%

Value	Count	Frequency (%)
365	300	1.8%
364	132	0.8%
363	74	0.4%
362	57	0.3%
361	36	0.2%
360	27	0.2%
359	48	0.3%
358	43	0.3%
357	24	0.1%
356	23	0.1%

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

	id	name	host_id	host_name	neighbourhood_group	neighbourhood	latitude	longitude	room_type	price	minimum_nights	number_of_reviews	last_review	reviews_per_month	calculated_host_listings_count	availability_365
0	9138664	Private Lg Room 15 min to Manhattan	47594947	Iris	Queens	Sunnyside	40.74271	-73.92493	Private room	74	2	6	2019-05-26	0.13	1	5
1	31444015	TIME SQUARE CHARMING ONE BED IN HELL'S KITCHEN,NYC	8523790	Johlex	Manhattan	Hell's Kitchen	40.76682	-73.98878	Entire home/apt	170	3	0	NaT	NaN	1	188
2	8741020	Voted #1 Location Quintessential 1BR W Village Apt	45854238	John	Manhattan	West Village	40.73631	-74.00611	Entire home/apt	245	3	51	2018-09-19	1.12	1	0
3	34602077	Spacious 1 bedroom apartment 15min from Manhattan	261055465	Regan	Queens	Astoria	40.76424	-73.92351	Entire home/apt	125	3	1	2019-05-24	0.65	1	13
4	23203149	Big beautiful bedroom in huge Bushwick apartment	143460	Megan	Brooklyn	Bushwick	40.69839	-73.92044	Private room	65	2	8	2019-06-23	0.52	2	8
5	4402805	LRG 2br BKLYN APT CLOSE TO TRAINS AND PARK	22807362	Jenny	Brooklyn	Prospect-Lefferts Gardens	40.66025	-73.96270	Entire home/apt	120	3	3	2018-08-28	0.05	1	16
6	30070126	✩Prime Renovated 1/1 Apartment in Upper East Side✩	4968673	Sean	Manhattan	Upper East Side	40.76831	-73.95929	Entire home/apt	200	5	2	2019-05-26	0.68	1	71
7	34231172	Fully renovated brick house floor in Brooklyn	59642348	Kevin	Brooklyn	Sunset Park	40.64550	-74.01262	Entire home/apt	95	1	9	2019-07-08	9.00	1	106
8	5856760	Renovated 1BR in exciting, convenient area	29408349	Chad	Manhattan	Chinatown	40.71490	-73.99976	Entire home/apt	179	5	7	2017-04-18	0.14	1	0
9	7929441	Beautiful Loft w/ Waterfront View!	1453898	Anthony	Brooklyn	Williamsburg	40.71268	-73.96676	Private room	105	2	232	2019-06-19	5.00	3	64

	id	name	host_id	host_name	neighbourhood_group	neighbourhood	latitude	longitude	room_type	price	minimum_nights	number_of_reviews	last_review	reviews_per_month	calculated_host_listings_count	availability_365
19990	5192459	Quiet Room in 4BR UWS Brownstone	10677483	Greg	Manhattan	Upper West Side	40.80173	-73.96625	Private room	70	1	0	NaT	NaN	1	0
19991	1327940	Huge Gorgeous Park View Apartment!	3290436	Hadar	Brooklyn	Flatbush	40.65335	-73.96257	Entire home/apt	120	3	13	2016-08-27	0.28	2	327
19992	23612681	Shared Room 1 Stop from Manhattan on the F Train	55724558	Taylor	Queens	Long Island City	40.76006	-73.94080	Private room	55	4	2	2019-06-01	0.65	5	89
19993	34485745	Midtown Manhattan Stunner - Private room	261632622	Royalton	Manhattan	Theater District	40.75491	-73.98507	Private room	100	1	3	2019-06-16	3.00	9	318
19994	25616250	Stylish, spacious, private 1BR apt in Ditmas Park	125396920	Adam	Brooklyn	Flatbush	40.64314	-73.95705	Entire home/apt	75	3	10	2019-01-03	0.84	1	0
19995	7094539	Tranquil haven in bubbly Brooklyn	2052211	Adriana	Brooklyn	Windsor Terrace	40.65360	-73.97546	Entire home/apt	143	14	2	2016-08-27	0.04	1	10
19996	4424261	Large 1 BR with backyard on UWS	3447311	Sarah	Manhattan	Upper West Side	40.80188	-73.96808	Entire home/apt	200	2	22	2019-05-21	0.50	1	0
19997	4545882	Amazing studio/Loft with a backyard	23569951	Kaveh	Manhattan	Upper East Side	40.78110	-73.94567	Entire home/apt	220	3	28	2019-05-23	0.50	1	293
19998	26518547	U2 comfortable double bed sleeps 2 guests	295128	Carol Gloria	Bronx	Clason Point	40.81225	-73.85502	Private room	80	1	4	2019-07-01	1.48	7	365
19999	33631782	Private Bedroom in Williamsburg Apt!	8569221	Andi	Brooklyn	Williamsburg	40.71829	-73.95819	Private room	109	3	3	2019-04-28	1.07	2	97

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Missing values

Sample